SpdrRiskGroupCancel

V8 Message Definiton

Records inserted into this table causes the corresponding parent broker to cancel the current underlying parent order if active and cancellable.

METADATA

Attribute	Value
Topic	3985-parent-orders
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT,INSERT,DELETE

Table Definition

Field	Type	Key	Default Value	Comment
riskGroupId	BIGINT	PRI	0	all orders with the same riskGroupId share a common set of risk countersGrp risk limits apply to these shared counters
accnt	VARCHAR(16)	PRI	''	SR trading account
clientFirm	VARCHAR(16)	PRI	''	SR client firm
sysEnvironment	enum - SysEnvironment		'None'	original source sys environment Stable Current etc
runStatus	enum - RunStatus		'None'	original source run status ProdBeta
spdrSource	enum - SpdrSource		'None'
cxlReason	VARCHAR(16)		''
altCancelId	VARCHAR(24)		''
userName	VARCHAR(24)		''
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
riskGroupId	1
accnt	2
clientFirm	3

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSRRiskGroupCancel` (
    `riskGroupId` BIGINT NOT NULL DEFAULT 0 COMMENT 'all orders with the same riskGroupId share a common set of risk counters;.Grp. risk limits apply to these shared counters',
    `accnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR trading account',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR client firm',
    `sysEnvironment` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None' COMMENT 'original (source) sys environment [Stable, Current, etc]',
    `runStatus` ENUM('None','Prod','Beta','UAT','SysTest') NOT NULL DEFAULT 'None' COMMENT 'original (source) run status [Prod,Beta]',
    `spdrSource` ENUM('None','SpdrTicket','SpdrSingle','SRSE','FIX','HedgeTool','TradeHedge','OpenHedge','AutoHedge','Orphan','RiskManager','OrderManager','ManagedOrder','RFQRespSrvr','Legger','SRSEDrop','FixDrop','TicketDrop','SysTest','RFRResponse','AllocOmni','AllocClient','CertGateway','MLegResponse','LeggerX','DropManager','AutoHedgeSrvr','AuctionStrategySrvr','AllocBlockFace','AllocBlockCust','IceChatGateway','EXS2SRC','MLinkResponse','AutoResponderVD','AutoResponderRC','AutoResponderSN','AutoResponderBX','MLink') NOT NULL DEFAULT 'None',
    `cxlReason` VARCHAR(16) NOT NULL DEFAULT '',
    `altCancelId` VARCHAR(24) NOT NULL DEFAULT '',
    `userName` VARCHAR(24) NOT NULL DEFAULT '',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    PRIMARY KEY USING HASH (`riskGroupId`,`accnt`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='Records inserted into this table causes the corresponding parent broker to cancel the current underlying parent order if active and cancellable.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `riskGroupId`,
    `accnt`,
    `clientFirm`,
    `sysEnvironment`,
    `runStatus`,
    `spdrSource`,
    `cxlReason`,
    `altCancelId`,
    `userName`,
    `timestamp`
FROM `SRTrade`.`MsgSRRiskGroupCancel`
WHERE 
    /* Replace with a BIGINT */ 
    `riskGroupId` = 1234567890
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgSRRiskGroupCancel`(
    /* Replace with a BIGINT */ 
    `riskGroupId`,
    /* Replace with a VARCHAR(16) */ 
    `accnt`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') */ 
    `sysEnvironment`,
    /* Replace with a ENUM('None','Prod','Beta','UAT','SysTest') */ 
    `runStatus`,
    /* Replace with a ENUM('None','SpdrTicket','SpdrSingle','SRSE','FIX','HedgeTool','TradeHedge','OpenHedge','AutoHedge','Orphan','RiskManager','OrderManager','ManagedOrder','RFQRespSrvr','Legger','SRSEDrop','FixDrop','TicketDrop','SysTest','RFRResponse','AllocOmni','AllocClient','CertGateway','MLegResponse','LeggerX','DropManager','AutoHedgeSrvr','AuctionStrategySrvr','AllocBlockFace','AllocBlockCust','IceChatGateway','EXS2SRC','MLinkResponse','AutoResponderVD','AutoResponderRC','AutoResponderSN','AutoResponderBX','MLink') */ 
    `spdrSource`,
    /* Replace with a VARCHAR(16) */ 
    `cxlReason`,
    /* Replace with a VARCHAR(24) */
    `altCancelId`,
    /* Replace with a VARCHAR(24) */ 
    `userName`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    1234567890,
    'Example_accnt',
    'Example_clientFirm',
    'None',
    'None',
    'None',
    'Example_cxlReason',
    'Example_altCancelId',
    'Example_userName',
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRTrade`.`MsgSRRiskGroupCancel` 
WHERE
    /* Replace with a BIGINT */ 
    `riskGroupId` = 1234567890
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SpdrRiskGroupCancel' ORDER BY ordinal_position ASC;